package com.koron.css2.newProjectCenter.function.mapper;

import com.koron.css2.newProjectCenter.function.bean.UserDetail;
import com.koron.css2.newProjectCenter.function.vo.DeptInfoVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserInfoMapper {
    @Select("select departmentCode, departmentName from tblstaff where code = #{account}")
    DeptInfoVo getDeptInfoByUserAccount(@Param("account") String account);

    @Select("select name as departmentName, code as departmentCode from tbldepartment")
    List<DeptInfoVo> getDeptType();

    List<UserDetail> getUserInfoListByPage();
}
